[dbo].[fn_asi_generate_login]
create function dbo.fn_asi_generate_login(@ID varchar(10))
returns varchar(60)
as
begin
DECLARE @outstring varchar(60)
SELECT @outstring = LEFT(isnull(a.FIRST_NAME,''),1) + isnull(a.LAST_NAME,'') + a.ID
FROM Name a, Name_Security b
WHERE a.ID = b.ID
AND a.ID = @ID
SET @outstring = UPPER(dbo.fn_asi_convert_foreign_string(@outstring))
return @outstring
end
GO
GRANT EXECUTE ON [dbo].[fn_asi_generate_login] TO [IMIS]
GO
